update <@PREFIX>order set order_status_id = <@UPDTOCODE@>, date_modified = now() where order_id = <@ORDERS_ID@>
@@GO@@
INSERT INTO <@PREFIX>order_history (order_history_id, order_id, order_status_id, date_added) values  ('', <@ORDERS_ID@>, <@UPDTOCODE@>, NOW())
@@GO@@